const connection=require('../app/database')

class LabelService{
  async create(name){
    const statement=`INSERT INTO label (name) VALUES (?);`

    const [result]=await connection.execute(statement,[name])
    return result
  }

  async getLabelByName(name){
    const statement=`SELECT * FROM label WHERE name=?;`

    const [result]=await connection.execute(statement,[name])
    return result[0]
  }

  async getLabels(limit,offset){
    const statement=`SELECT * FROM label LIMIT ?,?;`

    const [result]=await connection.execute(statement,[offset,limit])
    return result
  }
}

module.exports=new LabelService()